﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace GeoVision.Addin.UI.SQLSpatial
{
    public static class SQLQueryText
    {
        public static string SelectGeographyQuery = "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'{0}' and DATA_TYPE='geography'";
        public static string SelectGeometryQuery = "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'{0}' and DATA_TYPE='geometry'";
        public static string SelectTableNamesQuery = "SELECT [name] FROM dbo.sysobjects  WHERE xtype ='U'";
        public static string SelectAllUserDatabasesQuery = "SELECT [name] FROM master.dbo.sysdatabases WHERE dbid > 6";
    }
}
